﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master"
    CodeBehind="Search.aspx.vb" Inherits="HausaMathTermdev.Search" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <table width="100%">

     <tr>
            <td align="left">
                <h1>Search Based on Math Term</h1>
            </td>
            
        </tr>
        <tr>
            <td align="left">
                Enter the Math Term :<asp:TextBox ID="TB_Search" runat="server"></asp:TextBox>
                  <asp:Button ID="btn_Search" runat="server" Text="Search" />
            </td>
            
        </tr>
        <tr>
            <td align="center" colspan="2">
                <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AllowPaging="True"
                    AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="TermID" Width="100%">
                    <Columns>
                        <asp:BoundField DataField="Hausaterm" HeaderText="Hausa Term" SortExpression="Hausaterm">
                            <ControlStyle CssClass="fontsize" Font-Bold="False" />
                            <HeaderStyle CssClass="fontsize" HorizontalAlign="Center" VerticalAlign="Middle" />
                        </asp:BoundField>
                        <asp:HyperLinkField DataNavigateUrlFields="TermID" DataNavigateUrlFormatString="details.aspx?TermID={0}"
                            DataTextField="Mathterm" HeaderText="Math Term" SortExpression="Mathterm" />
                        <asp:ImageField DataAlternateTextField="PictureSymbol" DataImageUrlField="PictureSymbol"
                            DataImageUrlFormatString="/image/{0}" HeaderText=" Thumbnail" SortExpression="PictureSymbol">
                            <ControlStyle CssClass="Thumbnail" />
                            <ItemStyle CssClass="Thumbnail" />
                        </asp:ImageField>
                        <asp:BoundField DataField="Category" HeaderText="Category" SortExpression="Category" />
                        <asp:BoundField DataField="Author" HeaderText="Author" SortExpression="Author" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                    ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT [TermID], [Mathterm], [Hausaterm], [Definition], [PictureSymbol], [SiteAdd], [Remark], [Category], [Author], [DDate] FROM [Terms] WHERE ([Mathterm] Like '%' + @Mathterm + '%')">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="Mathterm" QueryStringField="Mathterm" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
</asp:Content>
